{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":110,"n_cols":10,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Quadro do Projecto Hotel"]
[null,"Ex. 5.11 - Sim. Projecto Hotel ",null,null,null,null,null,"(100 Runs)"]
[]
[null,null,"Tx Actualização",null,{"$f":"0.1","v":0.1}]
[null,null,"NPV(0,1) - Mil €",null,{"$f":"NPV(E5,F13:F20)","v":1298.136710167068},null,null,"Run","NPV - Mil €","TIR - %"]
[null,null,"IRR (%)",null,{"$f":"IRR(F13:F20)*100","v":19.417829342054805},null,null,"Média",{"$f":"AVERAGE(I10:I110)","v":595.24771652426216},{"$f":"AVERAGE(J10:J110)","v":13.84977213645719}]
[null,null,null,null,null,null,null,"D. Padrão (*)",{"$f":"STDEV(I10:I110)","v":828.57613881190696},{"$f":"STDEV(J10:J110)","v":6.1383914564835047}]
[]
[null,null,null,null,null,null,null,null,{"$f":"+E6","v":1298.136710167068},{"$f":"+E7","v":19.417829342054805}]
[null,null,null,null,null,null,null,1,422.74257933906523,13.198265744659388]
[null,"Ano",null,"Cash - Flow (Mil €)",null,"Gerado",null,{"$f":"+H11+1","v":2},248.71274554511976,12.086745802498843]
[null,0,"Normal(μ;σ)",-800,null,{"$f":"+D13","v":-800},null,{"$f":"+H12+1","v":3},-339.21737111139959,6.4138775538404635]
[null,1,"Normal(μ;σ)",-800,50,{"$f":"NORMINV(RAND(),D14,E14)","v":-821.88285552754292},null,4,36.160682722417974,10.322895498729068]
[null,2,"Normal(μ;σ)",-800,100,-653.68603456183007,null,5,-269.60613446752131,7.0746775523849781]
[null,3,"Normal(μ;σ)",-700,150,-464.4798442962055,null,6,-775.22150221856896,2.26995021472709]
[null,4,"Normal(μ;σ)",300,200,3.1672372207531225,null,7,2193.1042134421714,23.902634463889139]
[null,5,"Normal(μ;σ)",400,200,486.83929245172806,null,8,1243.0841776246873,19.027246229283868]
[null,6,"Normal(μ;σ)",500,200,524.67019673819436,null,9,-396.68015065838227,6.3338575818960408]
[null,7,"Uniforme(a;b",2000,8440,{"$f":"+D20+RAND()*(E20-D20)","v":6360.0451017223941},null,10,1629.1295957392313,21.720020744389323]
[null,null,null,null,null,null,null,11,149.13902529776391,11.161413605894532]
[null,null,null,null,null,null,null,12,-689.87122298711495,2.4448583024193393]
[null,null,null,null,null,null,null,13,-266.2453427643876,7.828491249375924]
[null,"Intervalo de Confiança a ",null,0.95,null,null,null,14,297.40988042219169,12.154261778429131]
[null,null,null,null,null,null,null,15,420.32494074098514,13.37706835897432]
[null,"NPV",null,null,"IRR",null,null,16,800.72692973743244,16.47370668842083]
[null,"L. Inferior","L. Superior",null,"L. Inferior","L. Superior",null,17,-116.71895923051662,9.0308955333072927]
[null,null,null,null,null,null,null,18,-358.85541887065318,6.6282431575007461]
[null,{"$f":"+$I$7-$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":430.84023449320159},{"$f":"+$I$7+$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":759.65519855532273},null,{"$f":"+$J$7-$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":12.63178209811441},{"$f":"+$J$7+$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":15.06776217479997},null,19,1670.7753484378231,21.362079851662784]
[null,null,null,null,null,null,null,20,39.972243475096171,10.369988150960531]
[null,null,null,null,null,null,null,21,394.1491505996803,13.048443675372035]
[null,"(*) O Excel já dá o Desvio Padrão Corrigido.",null,null,null,null,null,22,1075.8659137657196,17.743249718689302]
[null,null,null,null,null,null,null,23,-894.31610542144153,0.24289225932538905]
[null,null,null,null,null,null,null,24,665.84950073781113,15.100656512377864]
[null,null,null,null,null,null,null,25,1575.6061655778096,21.035071199867961]
[null,null,null,null,null,null,null,26,-24.458480519238449,9.774318794516379]
[null,null,null,null,null,null,null,27,1641.4556410321277,21.884564020033537]
[null,null,null,null,null,null,null,28,205.25559903288632,11.595067514791712]
[null,null,null,null,null,null,null,29,-279.28570317118761,7.3302759146708585]
[null,null,null,null,null,null,null,30,1594.9028783373615,20.931862476551721]
[null,null,null,null,null,null,null,31,550.20680941426235,14.138319568780489]
[null,null,null,null,null,null,null,32,1720.7307561091027,21.729818081417541]
[null,null,null,null,null,null,null,33,-534.79761878480713,4.5419159985079505]
[null,null,null,null,null,null,null,34,1343.7728577777832,19.372280543522802]
[null,null,null,null,null,null,null,35,-125.54048204906228,8.9533875736591781]
[null,null,null,null,null,null,null,36,1444.7386647995652,19.517345914801787]
[null,null,null,null,null,null,null,37,1645.3387417814813,21.745749325663244]
[null,null,null,null,null,null,null,38,1954.4856503361636,22.742046435105046]
[null,null,null,null,null,null,null,39,292.79215291422378,12.245967278820991]
[null,null,null,null,null,null,null,40,1106.5157233298396,18.038636266184849]
[null,null,null,null,null,null,null,41,1169.4772553084906,18.735271724358228]
[null,null,null,null,null,null,null,42,-446.96394399619209,5.8378441205180209]
[null,null,null,null,null,null,null,43,233.88898229057179,11.935740985060983]
[null,null,null,null,null,null,null,44,1430.458917718752,19.344882252288809]
[null,null,null,null,null,null,null,45,822.99075630880816,15.9158698619422]
[null,null,null,null,null,null,null,46,-573.58366364655092,4.2459901891404694]
[null,null,null,null,null,null,null,47,1578.1229127265651,21.548883160230691]
[null,null,null,null,null,null,null,48,2232.5255836639244,24.236288971571462]
[null,null,null,null,null,null,null,49,555.82038758251008,14.501113196286752]
[null,null,null,null,null,null,null,50,612.39801234730749,14.612997654444593]
[null,null,null,null,null,null,null,51,1013.9801852590276,17.82294270382836]
[null,null,null,null,null,null,null,52,-684.84820186913794,3.0961837296015426]
[null,null,null,null,null,null,null,53,-249.76144663401905,7.636454935813819]
[null,null,null,null,null,null,null,54,1984.3304389625439,22.944213741861997]
[null,null,null,null,null,null,null,55,717.60446119110031,15.571904841021578]
[null,null,null,null,null,null,null,56,-51.533086638305569,9.5771780992556685]
[null,null,null,null,null,null,null,57,1245.6180294993389,18.953024871519109]
[null,null,null,null,null,null,null,58,754.30669672856948,15.790352069823044]
[null,null,null,null,null,null,null,59,1097.6284721228019,17.815070254188136]
[null,null,null,null,null,null,null,60,1162.7736922981148,18.314034269060684]
[null,null,null,null,null,null,null,61,-455.15585262610432,5.5034322925759938]
[null,null,null,null,null,null,null,62,489.45219977210064,14.039597861720953]
[null,null,null,null,null,null,null,63,9.5160909821772126,10.082771020926518]
[null,null,null,null,null,null,null,64,1776.2310678357169,22.511219843065721]
[null,null,null,null,null,null,null,65,-49.411053122789568,9.5637276787663659]
[null,null,null,null,null,null,null,66,-463.01859854680822,5.2745071620813322]
[null,null,null,null,null,null,null,{"$f":"+H76+1","v":67},-417.52422683795533,6.1230193700406055]
[null,null,null,null,null,null,null,68,1373.3946820306535,19.549165136600678]
[null,null,null,null,null,null,null,69,531.16866671394951,14.083770552757112]
[null,null,null,null,null,null,null,70,1770.7602576694071,20.855532249238571]
[null,null,null,null,null,null,null,71,183.83333762780981,11.484647777955281]
[null,null,null,null,null,null,null,72,1001.5922342702878,17.25543094065911]
[null,null,null,null,null,null,null,73,-445.50412863422355,6.0483879207161806]
[null,null,null,null,null,null,null,74,-300.13601384804525,7.1753377843065014]
[null,null,null,null,null,null,null,75,-591.44301533837586,4.6435013640213851]
[null,null,null,null,null,null,null,76,340.80511721521566,12.687098739882474]
[null,null,null,null,null,null,null,77,1202.7093391337671,18.464344669507948]
[null,null,null,null,null,null,null,78,1123.1155421952565,17.878783201295899]
[null,null,null,null,null,null,null,79,-64.000949258694902,9.4591805447703301]
[null,null,null,null,null,null,null,80,77.397536643552058,10.613583239338942]
[null,null,null,null,null,null,null,81,1931.6143899632766,22.792544137842775]
[null,null,null,null,null,null,null,82,1143.7462688679614,18.013761760086624]
[null,null,null,null,null,null,null,83,61.079001682223236,10.571185143767337]
[null,null,null,null,null,null,null,84,1591.8823841596554,19.989036840233275]
[null,null,null,null,null,null,null,85,1244.9988696037499,18.636270119242425]
[null,null,null,null,null,null,null,86,-284.30926149913722,7.413514511586583]
[null,null,null,null,null,null,null,87,-934.28318890882065,-0.12835689610404266]
[null,null,null,null,null,null,null,88,398.68321316446304,13.454937256620614]
[null,null,null,null,null,null,null,89,710.93875995625683,15.362713616208335]
[null,null,null,null,null,null,null,90,1589.5694038946231,19.922783812463663]
[null,null,null,null,null,null,null,91,1144.9617645081687,17.966213326390058]
[null,null,null,null,null,null,null,92,1878.4145882292617,22.354609371125612]
[null,null,null,null,null,null,null,93,1434.8044105699478,19.729406649370794]
[null,null,null,null,null,null,null,94,-201.49828960183183,8.3196007232591676]
[null,null,null,null,null,null,null,95,1759.0682738484254,20.712633917662735]
[null,null,null,null,null,null,null,96,225.52384886123488,11.730505500326993]
[null,null,null,null,null,null,null,97,902.58925948277215,16.746198947086178]
[null,null,null,null,null,null,null,98,559.49295259575138,14.154415506696495]
[null,null,null,null,null,null,null,99,-117.20343778388889,8.9843396669222244]
[null,null,null,null,null,null,null,100,790.65869627269603,16.056514411385159]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}